package cn.edu.zjgsu.ito.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import cn.edu.zjgsu.ito.util.Paginator;

public class OrderDetailInfomationViewExample extends Paginator{
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public OrderDetailInfomationViewExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andUserIdIsNull() {
            addCriterion("user_id is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("user_id is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(Integer value) {
            addCriterion("user_id =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(Integer value) {
            addCriterion("user_id <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(Integer value) {
            addCriterion("user_id >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("user_id >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(Integer value) {
            addCriterion("user_id <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("user_id <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<Integer> values) {
            addCriterion("user_id in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<Integer> values) {
            addCriterion("user_id not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(Integer value1, Integer value2) {
            addCriterion("user_id between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("user_id not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andNicknameIsNull() {
            addCriterion("nickname is null");
            return (Criteria) this;
        }

        public Criteria andNicknameIsNotNull() {
            addCriterion("nickname is not null");
            return (Criteria) this;
        }

        public Criteria andNicknameEqualTo(String value) {
            addCriterion("nickname =", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotEqualTo(String value) {
            addCriterion("nickname <>", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameGreaterThan(String value) {
            addCriterion("nickname >", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameGreaterThanOrEqualTo(String value) {
            addCriterion("nickname >=", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLessThan(String value) {
            addCriterion("nickname <", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLessThanOrEqualTo(String value) {
            addCriterion("nickname <=", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLike(String value) {
            addCriterion("nickname like", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotLike(String value) {
            addCriterion("nickname not like", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameIn(List<String> values) {
            addCriterion("nickname in", values, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotIn(List<String> values) {
            addCriterion("nickname not in", values, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameBetween(String value1, String value2) {
            addCriterion("nickname between", value1, value2, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotBetween(String value1, String value2) {
            addCriterion("nickname not between", value1, value2, "nickname");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlIsNull() {
            addCriterion("head_portrait_url is null");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlIsNotNull() {
            addCriterion("head_portrait_url is not null");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlEqualTo(String value) {
            addCriterion("head_portrait_url =", value, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlNotEqualTo(String value) {
            addCriterion("head_portrait_url <>", value, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlGreaterThan(String value) {
            addCriterion("head_portrait_url >", value, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlGreaterThanOrEqualTo(String value) {
            addCriterion("head_portrait_url >=", value, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlLessThan(String value) {
            addCriterion("head_portrait_url <", value, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlLessThanOrEqualTo(String value) {
            addCriterion("head_portrait_url <=", value, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlLike(String value) {
            addCriterion("head_portrait_url like", value, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlNotLike(String value) {
            addCriterion("head_portrait_url not like", value, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlIn(List<String> values) {
            addCriterion("head_portrait_url in", values, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlNotIn(List<String> values) {
            addCriterion("head_portrait_url not in", values, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlBetween(String value1, String value2) {
            addCriterion("head_portrait_url between", value1, value2, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andHeadPortraitUrlNotBetween(String value1, String value2) {
            addCriterion("head_portrait_url not between", value1, value2, "headPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("order_id is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("order_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(Integer value) {
            addCriterion("order_id =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(Integer value) {
            addCriterion("order_id <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(Integer value) {
            addCriterion("order_id >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_id >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(Integer value) {
            addCriterion("order_id <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(Integer value) {
            addCriterion("order_id <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<Integer> values) {
            addCriterion("order_id in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<Integer> values) {
            addCriterion("order_id not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(Integer value1, Integer value2) {
            addCriterion("order_id between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(Integer value1, Integer value2) {
            addCriterion("order_id not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderStateIsNull() {
            addCriterion("order_state is null");
            return (Criteria) this;
        }

        public Criteria andOrderStateIsNotNull() {
            addCriterion("order_state is not null");
            return (Criteria) this;
        }

        public Criteria andOrderStateEqualTo(Integer value) {
            addCriterion("order_state =", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateNotEqualTo(Integer value) {
            addCriterion("order_state <>", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateGreaterThan(Integer value) {
            addCriterion("order_state >", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_state >=", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateLessThan(Integer value) {
            addCriterion("order_state <", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateLessThanOrEqualTo(Integer value) {
            addCriterion("order_state <=", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateIn(List<Integer> values) {
            addCriterion("order_state in", values, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateNotIn(List<Integer> values) {
            addCriterion("order_state not in", values, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateBetween(Integer value1, Integer value2) {
            addCriterion("order_state between", value1, value2, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateNotBetween(Integer value1, Integer value2) {
            addCriterion("order_state not between", value1, value2, "orderState");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeIsNull() {
            addCriterion("demand_createtime is null");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeIsNotNull() {
            addCriterion("demand_createtime is not null");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeEqualTo(Date value) {
            addCriterion("demand_createtime =", value, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeNotEqualTo(Date value) {
            addCriterion("demand_createtime <>", value, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeGreaterThan(Date value) {
            addCriterion("demand_createtime >", value, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("demand_createtime >=", value, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeLessThan(Date value) {
            addCriterion("demand_createtime <", value, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("demand_createtime <=", value, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeIn(List<Date> values) {
            addCriterion("demand_createtime in", values, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeNotIn(List<Date> values) {
            addCriterion("demand_createtime not in", values, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeBetween(Date value1, Date value2) {
            addCriterion("demand_createtime between", value1, value2, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andDemandCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("demand_createtime not between", value1, value2, "demandCreatetime");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdIsNull() {
            addCriterion("purchase_user_id is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdIsNotNull() {
            addCriterion("purchase_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdEqualTo(Integer value) {
            addCriterion("purchase_user_id =", value, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdNotEqualTo(Integer value) {
            addCriterion("purchase_user_id <>", value, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdGreaterThan(Integer value) {
            addCriterion("purchase_user_id >", value, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("purchase_user_id >=", value, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdLessThan(Integer value) {
            addCriterion("purchase_user_id <", value, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("purchase_user_id <=", value, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdIn(List<Integer> values) {
            addCriterion("purchase_user_id in", values, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdNotIn(List<Integer> values) {
            addCriterion("purchase_user_id not in", values, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdBetween(Integer value1, Integer value2) {
            addCriterion("purchase_user_id between", value1, value2, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("purchase_user_id not between", value1, value2, "purchaseUserId");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeIsNull() {
            addCriterion("accept_time is null");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeIsNotNull() {
            addCriterion("accept_time is not null");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeEqualTo(Date value) {
            addCriterion("accept_time =", value, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeNotEqualTo(Date value) {
            addCriterion("accept_time <>", value, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeGreaterThan(Date value) {
            addCriterion("accept_time >", value, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("accept_time >=", value, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeLessThan(Date value) {
            addCriterion("accept_time <", value, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeLessThanOrEqualTo(Date value) {
            addCriterion("accept_time <=", value, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeIn(List<Date> values) {
            addCriterion("accept_time in", values, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeNotIn(List<Date> values) {
            addCriterion("accept_time not in", values, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeBetween(Date value1, Date value2) {
            addCriterion("accept_time between", value1, value2, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeNotBetween(Date value1, Date value2) {
            addCriterion("accept_time not between", value1, value2, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeIsNull() {
            addCriterion("arrive_time is null");
            return (Criteria) this;
        }

        public Criteria andArriveTimeIsNotNull() {
            addCriterion("arrive_time is not null");
            return (Criteria) this;
        }

        public Criteria andArriveTimeEqualTo(Date value) {
            addCriterion("arrive_time =", value, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeNotEqualTo(Date value) {
            addCriterion("arrive_time <>", value, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeGreaterThan(Date value) {
            addCriterion("arrive_time >", value, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("arrive_time >=", value, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeLessThan(Date value) {
            addCriterion("arrive_time <", value, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeLessThanOrEqualTo(Date value) {
            addCriterion("arrive_time <=", value, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeIn(List<Date> values) {
            addCriterion("arrive_time in", values, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeNotIn(List<Date> values) {
            addCriterion("arrive_time not in", values, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeBetween(Date value1, Date value2) {
            addCriterion("arrive_time between", value1, value2, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeNotBetween(Date value1, Date value2) {
            addCriterion("arrive_time not between", value1, value2, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andCourierIdIsNull() {
            addCriterion("courier_id is null");
            return (Criteria) this;
        }

        public Criteria andCourierIdIsNotNull() {
            addCriterion("courier_id is not null");
            return (Criteria) this;
        }

        public Criteria andCourierIdEqualTo(Integer value) {
            addCriterion("courier_id =", value, "courierId");
            return (Criteria) this;
        }

        public Criteria andCourierIdNotEqualTo(Integer value) {
            addCriterion("courier_id <>", value, "courierId");
            return (Criteria) this;
        }

        public Criteria andCourierIdGreaterThan(Integer value) {
            addCriterion("courier_id >", value, "courierId");
            return (Criteria) this;
        }

        public Criteria andCourierIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("courier_id >=", value, "courierId");
            return (Criteria) this;
        }

        public Criteria andCourierIdLessThan(Integer value) {
            addCriterion("courier_id <", value, "courierId");
            return (Criteria) this;
        }

        public Criteria andCourierIdLessThanOrEqualTo(Integer value) {
            addCriterion("courier_id <=", value, "courierId");
            return (Criteria) this;
        }

        public Criteria andCourierIdIn(List<Integer> values) {
            addCriterion("courier_id in", values, "courierId");
            return (Criteria) this;
        }

        public Criteria andCourierIdNotIn(List<Integer> values) {
            addCriterion("courier_id not in", values, "courierId");
            return (Criteria) this;
        }

        public Criteria andCourierIdBetween(Integer value1, Integer value2) {
            addCriterion("courier_id between", value1, value2, "courierId");
            return (Criteria) this;
        }

        public Criteria andCourierIdNotBetween(Integer value1, Integer value2) {
            addCriterion("courier_id not between", value1, value2, "courierId");
            return (Criteria) this;
        }

        public Criteria andCourierAcceptTimeIsNull() {
            addCriterion("courier_accept_time is null");
            return (Criteria) this;
        }

        public Criteria andCourierAcceptTimeIsNotNull() {
            addCriterion("courier_accept_time is not null");
            return (Criteria) this;
        }

        public Criteria andCourierAcceptTimeEqualTo(Date value) {
            addCriterion("courier_accept_time =", value, "courierAcceptTime");
            return (Criteria) this;
        }

        public Criteria andCourierAcceptTimeNotEqualTo(Date value) {
            addCriterion("courier_accept_time <>", value, "courierAcceptTime");
            return (Criteria) this;
        }

        public Criteria andCourierAcceptTimeGreaterThan(Date value) {
            addCriterion("courier_accept_time >", value, "courierAcceptTime");
            return (Criteria) this;
        }

        public Criteria andCourierAcceptTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("courier_accept_time >=", value, "courierAcceptTime");
            return (Criteria) this;
        }

        public Criteria andCourierAcceptTimeLessThan(Date value) {
            addCriterion("courier_accept_time <", value, "courierAcceptTime");
            return (Criteria) this;
        }

        public Criteria andCourierAcceptTimeLessThanOrEqualTo(Date value) {
            addCriterion("courier_accept_time <=", value, "courierAcceptTime");
            return (Criteria) this;
        }

        public Criteria andCourierAcceptTimeIn(List<Date> values) {
            addCriterion("courier_accept_time in", values, "courierAcceptTime");
            return (Criteria) this;
        }

        public Criteria andCourierAcceptTimeNotIn(List<Date> values) {
            addCriterion("courier_accept_time not in", values, "courierAcceptTime");
            return (Criteria) this;
        }

        public Criteria andCourierAcceptTimeBetween(Date value1, Date value2) {
            addCriterion("courier_accept_time between", value1, value2, "courierAcceptTime");
            return (Criteria) this;
        }

        public Criteria andCourierAcceptTimeNotBetween(Date value1, Date value2) {
            addCriterion("courier_accept_time not between", value1, value2, "courierAcceptTime");
            return (Criteria) this;
        }

        public Criteria andReadNameIsNull() {
            addCriterion("read_name is null");
            return (Criteria) this;
        }

        public Criteria andReadNameIsNotNull() {
            addCriterion("read_name is not null");
            return (Criteria) this;
        }

        public Criteria andReadNameEqualTo(String value) {
            addCriterion("read_name =", value, "readName");
            return (Criteria) this;
        }

        public Criteria andReadNameNotEqualTo(String value) {
            addCriterion("read_name <>", value, "readName");
            return (Criteria) this;
        }

        public Criteria andReadNameGreaterThan(String value) {
            addCriterion("read_name >", value, "readName");
            return (Criteria) this;
        }

        public Criteria andReadNameGreaterThanOrEqualTo(String value) {
            addCriterion("read_name >=", value, "readName");
            return (Criteria) this;
        }

        public Criteria andReadNameLessThan(String value) {
            addCriterion("read_name <", value, "readName");
            return (Criteria) this;
        }

        public Criteria andReadNameLessThanOrEqualTo(String value) {
            addCriterion("read_name <=", value, "readName");
            return (Criteria) this;
        }

        public Criteria andReadNameLike(String value) {
            addCriterion("read_name like", value, "readName");
            return (Criteria) this;
        }

        public Criteria andReadNameNotLike(String value) {
            addCriterion("read_name not like", value, "readName");
            return (Criteria) this;
        }

        public Criteria andReadNameIn(List<String> values) {
            addCriterion("read_name in", values, "readName");
            return (Criteria) this;
        }

        public Criteria andReadNameNotIn(List<String> values) {
            addCriterion("read_name not in", values, "readName");
            return (Criteria) this;
        }

        public Criteria andReadNameBetween(String value1, String value2) {
            addCriterion("read_name between", value1, value2, "readName");
            return (Criteria) this;
        }

        public Criteria andReadNameNotBetween(String value1, String value2) {
            addCriterion("read_name not between", value1, value2, "readName");
            return (Criteria) this;
        }

        public Criteria andRewardIsNull() {
            addCriterion("reward is null");
            return (Criteria) this;
        }

        public Criteria andRewardIsNotNull() {
            addCriterion("reward is not null");
            return (Criteria) this;
        }

        public Criteria andRewardEqualTo(String value) {
            addCriterion("reward =", value, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardNotEqualTo(String value) {
            addCriterion("reward <>", value, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardGreaterThan(String value) {
            addCriterion("reward >", value, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardGreaterThanOrEqualTo(String value) {
            addCriterion("reward >=", value, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardLessThan(String value) {
            addCriterion("reward <", value, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardLessThanOrEqualTo(String value) {
            addCriterion("reward <=", value, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardLike(String value) {
            addCriterion("reward like", value, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardNotLike(String value) {
            addCriterion("reward not like", value, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardIn(List<String> values) {
            addCriterion("reward in", values, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardNotIn(List<String> values) {
            addCriterion("reward not in", values, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardBetween(String value1, String value2) {
            addCriterion("reward between", value1, value2, "reward");
            return (Criteria) this;
        }

        public Criteria andRewardNotBetween(String value1, String value2) {
            addCriterion("reward not between", value1, value2, "reward");
            return (Criteria) this;
        }

        public Criteria andCourierFeesIsNull() {
            addCriterion("courier_fees is null");
            return (Criteria) this;
        }

        public Criteria andCourierFeesIsNotNull() {
            addCriterion("courier_fees is not null");
            return (Criteria) this;
        }

        public Criteria andCourierFeesEqualTo(String value) {
            addCriterion("courier_fees =", value, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesNotEqualTo(String value) {
            addCriterion("courier_fees <>", value, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesGreaterThan(String value) {
            addCriterion("courier_fees >", value, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesGreaterThanOrEqualTo(String value) {
            addCriterion("courier_fees >=", value, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesLessThan(String value) {
            addCriterion("courier_fees <", value, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesLessThanOrEqualTo(String value) {
            addCriterion("courier_fees <=", value, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesLike(String value) {
            addCriterion("courier_fees like", value, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesNotLike(String value) {
            addCriterion("courier_fees not like", value, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesIn(List<String> values) {
            addCriterion("courier_fees in", values, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesNotIn(List<String> values) {
            addCriterion("courier_fees not in", values, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesBetween(String value1, String value2) {
            addCriterion("courier_fees between", value1, value2, "courierFees");
            return (Criteria) this;
        }

        public Criteria andCourierFeesNotBetween(String value1, String value2) {
            addCriterion("courier_fees not between", value1, value2, "courierFees");
            return (Criteria) this;
        }

        public Criteria andAddressIdIsNull() {
            addCriterion("address_id is null");
            return (Criteria) this;
        }

        public Criteria andAddressIdIsNotNull() {
            addCriterion("address_id is not null");
            return (Criteria) this;
        }

        public Criteria andAddressIdEqualTo(Integer value) {
            addCriterion("address_id =", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdNotEqualTo(Integer value) {
            addCriterion("address_id <>", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdGreaterThan(Integer value) {
            addCriterion("address_id >", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("address_id >=", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdLessThan(Integer value) {
            addCriterion("address_id <", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdLessThanOrEqualTo(Integer value) {
            addCriterion("address_id <=", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdIn(List<Integer> values) {
            addCriterion("address_id in", values, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdNotIn(List<Integer> values) {
            addCriterion("address_id not in", values, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdBetween(Integer value1, Integer value2) {
            addCriterion("address_id between", value1, value2, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdNotBetween(Integer value1, Integer value2) {
            addCriterion("address_id not between", value1, value2, "addressId");
            return (Criteria) this;
        }

        public Criteria andContactsIsNull() {
            addCriterion("contacts is null");
            return (Criteria) this;
        }

        public Criteria andContactsIsNotNull() {
            addCriterion("contacts is not null");
            return (Criteria) this;
        }

        public Criteria andContactsEqualTo(String value) {
            addCriterion("contacts =", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotEqualTo(String value) {
            addCriterion("contacts <>", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsGreaterThan(String value) {
            addCriterion("contacts >", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsGreaterThanOrEqualTo(String value) {
            addCriterion("contacts >=", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsLessThan(String value) {
            addCriterion("contacts <", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsLessThanOrEqualTo(String value) {
            addCriterion("contacts <=", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsLike(String value) {
            addCriterion("contacts like", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotLike(String value) {
            addCriterion("contacts not like", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsIn(List<String> values) {
            addCriterion("contacts in", values, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotIn(List<String> values) {
            addCriterion("contacts not in", values, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsBetween(String value1, String value2) {
            addCriterion("contacts between", value1, value2, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotBetween(String value1, String value2) {
            addCriterion("contacts not between", value1, value2, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneIsNull() {
            addCriterion("contacts_phone is null");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneIsNotNull() {
            addCriterion("contacts_phone is not null");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneEqualTo(String value) {
            addCriterion("contacts_phone =", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneNotEqualTo(String value) {
            addCriterion("contacts_phone <>", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneGreaterThan(String value) {
            addCriterion("contacts_phone >", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("contacts_phone >=", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneLessThan(String value) {
            addCriterion("contacts_phone <", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneLessThanOrEqualTo(String value) {
            addCriterion("contacts_phone <=", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneLike(String value) {
            addCriterion("contacts_phone like", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneNotLike(String value) {
            addCriterion("contacts_phone not like", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneIn(List<String> values) {
            addCriterion("contacts_phone in", values, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneNotIn(List<String> values) {
            addCriterion("contacts_phone not in", values, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneBetween(String value1, String value2) {
            addCriterion("contacts_phone between", value1, value2, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneNotBetween(String value1, String value2) {
            addCriterion("contacts_phone not between", value1, value2, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsIsNull() {
            addCriterion("address_details is null");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsIsNotNull() {
            addCriterion("address_details is not null");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsEqualTo(String value) {
            addCriterion("address_details =", value, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsNotEqualTo(String value) {
            addCriterion("address_details <>", value, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsGreaterThan(String value) {
            addCriterion("address_details >", value, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsGreaterThanOrEqualTo(String value) {
            addCriterion("address_details >=", value, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsLessThan(String value) {
            addCriterion("address_details <", value, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsLessThanOrEqualTo(String value) {
            addCriterion("address_details <=", value, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsLike(String value) {
            addCriterion("address_details like", value, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsNotLike(String value) {
            addCriterion("address_details not like", value, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsIn(List<String> values) {
            addCriterion("address_details in", values, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsNotIn(List<String> values) {
            addCriterion("address_details not in", values, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsBetween(String value1, String value2) {
            addCriterion("address_details between", value1, value2, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andAddressDetailsNotBetween(String value1, String value2) {
            addCriterion("address_details not between", value1, value2, "addressDetails");
            return (Criteria) this;
        }

        public Criteria andNoteIsNull() {
            addCriterion("note is null");
            return (Criteria) this;
        }

        public Criteria andNoteIsNotNull() {
            addCriterion("note is not null");
            return (Criteria) this;
        }

        public Criteria andNoteEqualTo(String value) {
            addCriterion("note =", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotEqualTo(String value) {
            addCriterion("note <>", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteGreaterThan(String value) {
            addCriterion("note >", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteGreaterThanOrEqualTo(String value) {
            addCriterion("note >=", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLessThan(String value) {
            addCriterion("note <", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLessThanOrEqualTo(String value) {
            addCriterion("note <=", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLike(String value) {
            addCriterion("note like", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotLike(String value) {
            addCriterion("note not like", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteIn(List<String> values) {
            addCriterion("note in", values, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotIn(List<String> values) {
            addCriterion("note not in", values, "note");
            return (Criteria) this;
        }

        public Criteria andNoteBetween(String value1, String value2) {
            addCriterion("note between", value1, value2, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotBetween(String value1, String value2) {
            addCriterion("note not between", value1, value2, "note");
            return (Criteria) this;
        }

        public Criteria andTradeNameIsNull() {
            addCriterion("trade_name is null");
            return (Criteria) this;
        }

        public Criteria andTradeNameIsNotNull() {
            addCriterion("trade_name is not null");
            return (Criteria) this;
        }

        public Criteria andTradeNameEqualTo(String value) {
            addCriterion("trade_name =", value, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameNotEqualTo(String value) {
            addCriterion("trade_name <>", value, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameGreaterThan(String value) {
            addCriterion("trade_name >", value, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameGreaterThanOrEqualTo(String value) {
            addCriterion("trade_name >=", value, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameLessThan(String value) {
            addCriterion("trade_name <", value, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameLessThanOrEqualTo(String value) {
            addCriterion("trade_name <=", value, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameLike(String value) {
            addCriterion("trade_name like", value, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameNotLike(String value) {
            addCriterion("trade_name not like", value, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameIn(List<String> values) {
            addCriterion("trade_name in", values, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameNotIn(List<String> values) {
            addCriterion("trade_name not in", values, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameBetween(String value1, String value2) {
            addCriterion("trade_name between", value1, value2, "tradeName");
            return (Criteria) this;
        }

        public Criteria andTradeNameNotBetween(String value1, String value2) {
            addCriterion("trade_name not between", value1, value2, "tradeName");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreIsNull() {
            addCriterion("purchase_store is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreIsNotNull() {
            addCriterion("purchase_store is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreEqualTo(String value) {
            addCriterion("purchase_store =", value, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreNotEqualTo(String value) {
            addCriterion("purchase_store <>", value, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreGreaterThan(String value) {
            addCriterion("purchase_store >", value, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_store >=", value, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreLessThan(String value) {
            addCriterion("purchase_store <", value, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreLessThanOrEqualTo(String value) {
            addCriterion("purchase_store <=", value, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreLike(String value) {
            addCriterion("purchase_store like", value, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreNotLike(String value) {
            addCriterion("purchase_store not like", value, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreIn(List<String> values) {
            addCriterion("purchase_store in", values, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreNotIn(List<String> values) {
            addCriterion("purchase_store not in", values, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreBetween(String value1, String value2) {
            addCriterion("purchase_store between", value1, value2, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchaseStoreNotBetween(String value1, String value2) {
            addCriterion("purchase_store not between", value1, value2, "purchaseStore");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceIsNull() {
            addCriterion("purchase_place is null");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceIsNotNull() {
            addCriterion("purchase_place is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceEqualTo(String value) {
            addCriterion("purchase_place =", value, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceNotEqualTo(String value) {
            addCriterion("purchase_place <>", value, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceGreaterThan(String value) {
            addCriterion("purchase_place >", value, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_place >=", value, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceLessThan(String value) {
            addCriterion("purchase_place <", value, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceLessThanOrEqualTo(String value) {
            addCriterion("purchase_place <=", value, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceLike(String value) {
            addCriterion("purchase_place like", value, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceNotLike(String value) {
            addCriterion("purchase_place not like", value, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceIn(List<String> values) {
            addCriterion("purchase_place in", values, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceNotIn(List<String> values) {
            addCriterion("purchase_place not in", values, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceBetween(String value1, String value2) {
            addCriterion("purchase_place between", value1, value2, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andPurchasePlaceNotBetween(String value1, String value2) {
            addCriterion("purchase_place not between", value1, value2, "purchasePlace");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyIsNull() {
            addCriterion("true_money is null");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyIsNotNull() {
            addCriterion("true_money is not null");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyEqualTo(String value) {
            addCriterion("true_money =", value, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyNotEqualTo(String value) {
            addCriterion("true_money <>", value, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyGreaterThan(String value) {
            addCriterion("true_money >", value, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyGreaterThanOrEqualTo(String value) {
            addCriterion("true_money >=", value, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyLessThan(String value) {
            addCriterion("true_money <", value, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyLessThanOrEqualTo(String value) {
            addCriterion("true_money <=", value, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyLike(String value) {
            addCriterion("true_money like", value, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyNotLike(String value) {
            addCriterion("true_money not like", value, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyIn(List<String> values) {
            addCriterion("true_money in", values, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyNotIn(List<String> values) {
            addCriterion("true_money not in", values, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyBetween(String value1, String value2) {
            addCriterion("true_money between", value1, value2, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andTrueMoneyNotBetween(String value1, String value2) {
            addCriterion("true_money not between", value1, value2, "trueMoney");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressIsNull() {
            addCriterion("purchase_address is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressIsNotNull() {
            addCriterion("purchase_address is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressEqualTo(String value) {
            addCriterion("purchase_address =", value, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressNotEqualTo(String value) {
            addCriterion("purchase_address <>", value, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressGreaterThan(String value) {
            addCriterion("purchase_address >", value, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_address >=", value, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressLessThan(String value) {
            addCriterion("purchase_address <", value, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressLessThanOrEqualTo(String value) {
            addCriterion("purchase_address <=", value, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressLike(String value) {
            addCriterion("purchase_address like", value, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressNotLike(String value) {
            addCriterion("purchase_address not like", value, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressIn(List<String> values) {
            addCriterion("purchase_address in", values, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressNotIn(List<String> values) {
            addCriterion("purchase_address not in", values, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressBetween(String value1, String value2) {
            addCriterion("purchase_address between", value1, value2, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseAddressNotBetween(String value1, String value2) {
            addCriterion("purchase_address not between", value1, value2, "purchaseAddress");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserNicknameIsNull() {
            addCriterion("purchase_user_nickname is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserNicknameIsNotNull() {
            addCriterion("purchase_user_nickname is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserNicknameEqualTo(String value) {
            addCriterion("purchase_user_nickname =", value, "purchaseUserNickname");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserNicknameNotEqualTo(String value) {
            addCriterion("purchase_user_nickname <>", value, "purchaseUserNickname");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserNicknameGreaterThan(String value) {
            addCriterion("purchase_user_nickname >", value, "purchaseUserNickname");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserNicknameGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_user_nickname >=", value, "purchaseUserNickname");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserNicknameLessThan(String value) {
            addCriterion("purchase_user_nickname <", value, "purchaseUserNickname");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserNicknameLessThanOrEqualTo(String value) {
            addCriterion("purchase_user_nickname <=", value, "purchaseUserNickname");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserNicknameLike(String value) {
            addCriterion("purchase_user_nickname like", value, "purchaseUserNickname");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserNicknameNotLike(String value) {
            addCriterion("purchase_user_nickname not like", value, "purchaseUserNickname");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserNicknameIn(List<String> values) {
            addCriterion("purchase_user_nickname in", values, "purchaseUserNickname");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserNicknameNotIn(List<String> values) {
            addCriterion("purchase_user_nickname not in", values, "purchaseUserNickname");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserNicknameBetween(String value1, String value2) {
            addCriterion("purchase_user_nickname between", value1, value2, "purchaseUserNickname");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserNicknameNotBetween(String value1, String value2) {
            addCriterion("purchase_user_nickname not between", value1, value2, "purchaseUserNickname");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserheadPortraitUrlIsNull() {
            addCriterion("purchase_userhead_portrait_url is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserheadPortraitUrlIsNotNull() {
            addCriterion("purchase_userhead_portrait_url is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserheadPortraitUrlEqualTo(String value) {
            addCriterion("purchase_userhead_portrait_url =", value, "purchaseUserheadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserheadPortraitUrlNotEqualTo(String value) {
            addCriterion("purchase_userhead_portrait_url <>", value, "purchaseUserheadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserheadPortraitUrlGreaterThan(String value) {
            addCriterion("purchase_userhead_portrait_url >", value, "purchaseUserheadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserheadPortraitUrlGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_userhead_portrait_url >=", value, "purchaseUserheadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserheadPortraitUrlLessThan(String value) {
            addCriterion("purchase_userhead_portrait_url <", value, "purchaseUserheadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserheadPortraitUrlLessThanOrEqualTo(String value) {
            addCriterion("purchase_userhead_portrait_url <=", value, "purchaseUserheadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserheadPortraitUrlLike(String value) {
            addCriterion("purchase_userhead_portrait_url like", value, "purchaseUserheadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserheadPortraitUrlNotLike(String value) {
            addCriterion("purchase_userhead_portrait_url not like", value, "purchaseUserheadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserheadPortraitUrlIn(List<String> values) {
            addCriterion("purchase_userhead_portrait_url in", values, "purchaseUserheadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserheadPortraitUrlNotIn(List<String> values) {
            addCriterion("purchase_userhead_portrait_url not in", values, "purchaseUserheadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserheadPortraitUrlBetween(String value1, String value2) {
            addCriterion("purchase_userhead_portrait_url between", value1, value2, "purchaseUserheadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andPurchaseUserheadPortraitUrlNotBetween(String value1, String value2) {
            addCriterion("purchase_userhead_portrait_url not between", value1, value2, "purchaseUserheadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andCourierNicknameIsNull() {
            addCriterion("courier_nickname is null");
            return (Criteria) this;
        }

        public Criteria andCourierNicknameIsNotNull() {
            addCriterion("courier_nickname is not null");
            return (Criteria) this;
        }

        public Criteria andCourierNicknameEqualTo(String value) {
            addCriterion("courier_nickname =", value, "courierNickname");
            return (Criteria) this;
        }

        public Criteria andCourierNicknameNotEqualTo(String value) {
            addCriterion("courier_nickname <>", value, "courierNickname");
            return (Criteria) this;
        }

        public Criteria andCourierNicknameGreaterThan(String value) {
            addCriterion("courier_nickname >", value, "courierNickname");
            return (Criteria) this;
        }

        public Criteria andCourierNicknameGreaterThanOrEqualTo(String value) {
            addCriterion("courier_nickname >=", value, "courierNickname");
            return (Criteria) this;
        }

        public Criteria andCourierNicknameLessThan(String value) {
            addCriterion("courier_nickname <", value, "courierNickname");
            return (Criteria) this;
        }

        public Criteria andCourierNicknameLessThanOrEqualTo(String value) {
            addCriterion("courier_nickname <=", value, "courierNickname");
            return (Criteria) this;
        }

        public Criteria andCourierNicknameLike(String value) {
            addCriterion("courier_nickname like", value, "courierNickname");
            return (Criteria) this;
        }

        public Criteria andCourierNicknameNotLike(String value) {
            addCriterion("courier_nickname not like", value, "courierNickname");
            return (Criteria) this;
        }

        public Criteria andCourierNicknameIn(List<String> values) {
            addCriterion("courier_nickname in", values, "courierNickname");
            return (Criteria) this;
        }

        public Criteria andCourierNicknameNotIn(List<String> values) {
            addCriterion("courier_nickname not in", values, "courierNickname");
            return (Criteria) this;
        }

        public Criteria andCourierNicknameBetween(String value1, String value2) {
            addCriterion("courier_nickname between", value1, value2, "courierNickname");
            return (Criteria) this;
        }

        public Criteria andCourierNicknameNotBetween(String value1, String value2) {
            addCriterion("courier_nickname not between", value1, value2, "courierNickname");
            return (Criteria) this;
        }

        public Criteria andCourierHeadPortraitUrlIsNull() {
            addCriterion("courier_head_portrait_url is null");
            return (Criteria) this;
        }

        public Criteria andCourierHeadPortraitUrlIsNotNull() {
            addCriterion("courier_head_portrait_url is not null");
            return (Criteria) this;
        }

        public Criteria andCourierHeadPortraitUrlEqualTo(String value) {
            addCriterion("courier_head_portrait_url =", value, "courierHeadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andCourierHeadPortraitUrlNotEqualTo(String value) {
            addCriterion("courier_head_portrait_url <>", value, "courierHeadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andCourierHeadPortraitUrlGreaterThan(String value) {
            addCriterion("courier_head_portrait_url >", value, "courierHeadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andCourierHeadPortraitUrlGreaterThanOrEqualTo(String value) {
            addCriterion("courier_head_portrait_url >=", value, "courierHeadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andCourierHeadPortraitUrlLessThan(String value) {
            addCriterion("courier_head_portrait_url <", value, "courierHeadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andCourierHeadPortraitUrlLessThanOrEqualTo(String value) {
            addCriterion("courier_head_portrait_url <=", value, "courierHeadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andCourierHeadPortraitUrlLike(String value) {
            addCriterion("courier_head_portrait_url like", value, "courierHeadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andCourierHeadPortraitUrlNotLike(String value) {
            addCriterion("courier_head_portrait_url not like", value, "courierHeadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andCourierHeadPortraitUrlIn(List<String> values) {
            addCriterion("courier_head_portrait_url in", values, "courierHeadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andCourierHeadPortraitUrlNotIn(List<String> values) {
            addCriterion("courier_head_portrait_url not in", values, "courierHeadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andCourierHeadPortraitUrlBetween(String value1, String value2) {
            addCriterion("courier_head_portrait_url between", value1, value2, "courierHeadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andCourierHeadPortraitUrlNotBetween(String value1, String value2) {
            addCriterion("courier_head_portrait_url not between", value1, value2, "courierHeadPortraitUrl");
            return (Criteria) this;
        }

        public Criteria andCourierUserIdIsNull() {
            addCriterion("courier_user_id is null");
            return (Criteria) this;
        }

        public Criteria andCourierUserIdIsNotNull() {
            addCriterion("courier_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andCourierUserIdEqualTo(Integer value) {
            addCriterion("courier_user_id =", value, "courierUserId");
            return (Criteria) this;
        }

        public Criteria andCourierUserIdNotEqualTo(Integer value) {
            addCriterion("courier_user_id <>", value, "courierUserId");
            return (Criteria) this;
        }

        public Criteria andCourierUserIdGreaterThan(Integer value) {
            addCriterion("courier_user_id >", value, "courierUserId");
            return (Criteria) this;
        }

        public Criteria andCourierUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("courier_user_id >=", value, "courierUserId");
            return (Criteria) this;
        }

        public Criteria andCourierUserIdLessThan(Integer value) {
            addCriterion("courier_user_id <", value, "courierUserId");
            return (Criteria) this;
        }

        public Criteria andCourierUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("courier_user_id <=", value, "courierUserId");
            return (Criteria) this;
        }

        public Criteria andCourierUserIdIn(List<Integer> values) {
            addCriterion("courier_user_id in", values, "courierUserId");
            return (Criteria) this;
        }

        public Criteria andCourierUserIdNotIn(List<Integer> values) {
            addCriterion("courier_user_id not in", values, "courierUserId");
            return (Criteria) this;
        }

        public Criteria andCourierUserIdBetween(Integer value1, Integer value2) {
            addCriterion("courier_user_id between", value1, value2, "courierUserId");
            return (Criteria) this;
        }

        public Criteria andCourierUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("courier_user_id not between", value1, value2, "courierUserId");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceIsNull() {
            addCriterion("demand_pay_price is null");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceIsNotNull() {
            addCriterion("demand_pay_price is not null");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceEqualTo(String value) {
            addCriterion("demand_pay_price =", value, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceNotEqualTo(String value) {
            addCriterion("demand_pay_price <>", value, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceGreaterThan(String value) {
            addCriterion("demand_pay_price >", value, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceGreaterThanOrEqualTo(String value) {
            addCriterion("demand_pay_price >=", value, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceLessThan(String value) {
            addCriterion("demand_pay_price <", value, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceLessThanOrEqualTo(String value) {
            addCriterion("demand_pay_price <=", value, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceLike(String value) {
            addCriterion("demand_pay_price like", value, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceNotLike(String value) {
            addCriterion("demand_pay_price not like", value, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceIn(List<String> values) {
            addCriterion("demand_pay_price in", values, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceNotIn(List<String> values) {
            addCriterion("demand_pay_price not in", values, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceBetween(String value1, String value2) {
            addCriterion("demand_pay_price between", value1, value2, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andDemandPayPriceNotBetween(String value1, String value2) {
            addCriterion("demand_pay_price not between", value1, value2, "demandPayPrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceIsNull() {
            addCriterion("estimate_the_price is null");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceIsNotNull() {
            addCriterion("estimate_the_price is not null");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceEqualTo(String value) {
            addCriterion("estimate_the_price =", value, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceNotEqualTo(String value) {
            addCriterion("estimate_the_price <>", value, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceGreaterThan(String value) {
            addCriterion("estimate_the_price >", value, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceGreaterThanOrEqualTo(String value) {
            addCriterion("estimate_the_price >=", value, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceLessThan(String value) {
            addCriterion("estimate_the_price <", value, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceLessThanOrEqualTo(String value) {
            addCriterion("estimate_the_price <=", value, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceLike(String value) {
            addCriterion("estimate_the_price like", value, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceNotLike(String value) {
            addCriterion("estimate_the_price not like", value, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceIn(List<String> values) {
            addCriterion("estimate_the_price in", values, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceNotIn(List<String> values) {
            addCriterion("estimate_the_price not in", values, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceBetween(String value1, String value2) {
            addCriterion("estimate_the_price between", value1, value2, "estimateThePrice");
            return (Criteria) this;
        }

        public Criteria andEstimateThePriceNotBetween(String value1, String value2) {
            addCriterion("estimate_the_price not between", value1, value2, "estimateThePrice");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}